A check constraint is the most generic constraint type. It allows you to specify that the value in a certain column must satisfy a Boolean (truth-value) expression.
Checks are managed on the Checks tab of the Table Designer. Just simply click a check field for editing. Using the toolbar below, you can create new, edit and delete the selected check field.
Add Check
To add a check
- Open the table in the Table Designer.
- Open the Checks tab.
- Click the
Add Check from the toolbar.
- Edit check properties.
Edit Check
To edit a check
- Open the table in the Table Designer.
- Open the Checks tab.
- Click on the check to edit.
Delete Check
To delete a check
- Open the table in the Table Designer.
- Open the Checks tab.
- Click the
Delete Check from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Check Properties